Round 1: Technical Discussion

📍 Project-Related Questions: Detailed questions regarding your project experience, focusing on the architecture, tools used, challenges faced, and how you approached various tasks.

📍 Data Warehousing Concepts: Questions on ETL processes, fact and dimension tables, normalization, and Slowly Changing Dimensions (SCD).

📍 Python Questions (Easy Difficulty): Math concepts, String manipulation.

Round 2 – Technical Discussion

📍 Current Company Projects: In-depth questions on your current projects, focusing on the tools used, challenges encountered, and your role in the projects.

📍 Google Cloud Platform (Scenario-Based): Scenario-based questions related to data storage, processing, and best practices for handling large datasets in Google Cloud.

📍 SQL Queries (Easy Difficulty): Basic SQL querying concepts.

Round 3 – Techno-Managerial

📍 Project-Related Questions: Focus on your problem-solving approach, decision-making process, and how you handled challenges in previous projects.

📍 BigQuery Architecture: Questions on the architecture of BigQuery, including its handling of large-scale data processing and its underlying features.

📍 Spark Optimizations: Discussion on optimization techniques in Spark, including partitioning, caching, and using broadcast joins to improve performance.

📍 Job Change and Motivation for Deloitte: Questions about your motivation for seeking a job change and why you consider Deloitte a good fit for your career goals.

Round 4 – Client

📍 Data Modeling Questions: Questions on database design, entity relationships, and ensuring scalability and performance in data modeling.

📍 SQL Queries on Data Modeling (Medium-Hard Difficulty): More advanced SQL queries focusing on data modeling.